Use BD_SYS_ALMACEN
Go
Create Procedure dbo.GRSubCategoria_Obtener(
   @iCodSub Int
)
As
Begin

   Select 
      iCodSub,
      iCodCat, 
      vNomSub,
      vDesSub,
      bActivoSub,
      iCodUsu,
      cNomTer,
      dtFecAct
   From GRSubCategoria a(Nolock)   
   Where iCodSub = @iCodSub
   
End